Release 10.1A: OpenEdge Data Management:
SQL Reference

CREATE TABLE

Syntax

create table statement ::= CREATE TABLE [ owner_name.]table_name ( { column_definition | table_constraint }, ... ) [ AREA area_name ] ; create table statement ::= CREATE TABLE [ owner_name.]table_name [ (column_name [ NULL | NOT NULL] , ...) ] [ AREA area_name ] AS query_expression ;

Column Definition

Syntax

column_definition ::= column_name data_type [ DEFAULT { literal | NULL | SYSDATE } ] [ column_constraint [ column_constraint ... ] ]

Column Constraint

Syntax

column_constraint ::= [ CONSTRAINT constraint_name ] NOT NULL [ PRIMARY KEY | UNIQUE ] | REFERENCES [ owner_name.]table_name [ ( column_name ) ] | CHECK ( search_condition )

Table Constraint

Syntax

table_constraint ::= [ CONSTRAINT constraint_name ] PRIMARY KEY ( column [, ... ] ) | UNIQUE ( column [, ...... ] ) | FOREIGN KEY ( column [, ... ] ) REFERENCES [ owner_name.]table_name [ ( column [, ... ] ) ] | CHECK ( search_condition )